Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	9999
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.5 MiB
Average record size in memory	362.6 B

Variable types

Numeric	12
Categorical	5

Alerts

`Date` has a high cardinality: 305 distinct values	High cardinality
`AccountMng_Pages` is highly correlated with `AccountMng_Duration`	High correlation
`AccountMng_Duration` is highly correlated with `AccountMng_Pages`	High correlation
`FAQ_Pages` is highly correlated with `FAQ_Duration`	High correlation
`FAQ_Duration` is highly correlated with `FAQ_Pages`	High correlation
`Product_Pages` is highly correlated with `Product_Duration` and 1 other fields	High correlation
`Product_Duration` is highly correlated with `Product_Pages`	High correlation
`GoogleAnalytics_BounceRate` is highly correlated with `GoogleAnalytics_ExitRate`	High correlation
`GoogleAnalytics_ExitRate` is highly correlated with `Product_Pages` and 1 other fields	High correlation
`GoogleAnalytics_PageValue` is highly correlated with `Buy`	High correlation
`Buy` is highly correlated with `GoogleAnalytics_PageValue`	High correlation
`AccountMng_Pages` is highly correlated with `AccountMng_Duration`	High correlation
`AccountMng_Duration` is highly correlated with `AccountMng_Pages`	High correlation
`FAQ_Pages` is highly correlated with `FAQ_Duration`	High correlation
`FAQ_Duration` is highly correlated with `FAQ_Pages`	High correlation
`Product_Pages` is highly correlated with `Product_Duration`	High correlation
`Product_Duration` is highly correlated with `Product_Pages`	High correlation
`GoogleAnalytics_BounceRate` is highly correlated with `GoogleAnalytics_ExitRate`	High correlation
`GoogleAnalytics_ExitRate` is highly correlated with `GoogleAnalytics_BounceRate`	High correlation
`AccountMng_Pages` is highly correlated with `AccountMng_Duration`	High correlation
`AccountMng_Duration` is highly correlated with `AccountMng_Pages`	High correlation
`FAQ_Pages` is highly correlated with `FAQ_Duration`	High correlation
`FAQ_Duration` is highly correlated with `FAQ_Pages`	High correlation
`Product_Pages` is highly correlated with `Product_Duration`	High correlation
`Product_Duration` is highly correlated with `Product_Pages`	High correlation
`GoogleAnalytics_PageValue` is highly correlated with `Buy`	High correlation
`Buy` is highly correlated with `GoogleAnalytics_PageValue`	High correlation
`AccountMng_Pages` is highly correlated with `Product_Pages`	High correlation
`AccountMng_Duration` is highly correlated with `FAQ_Duration` and 1 other fields	High correlation
`FAQ_Pages` is highly correlated with `FAQ_Duration` and 2 other fields	High correlation
`FAQ_Duration` is highly correlated with `AccountMng_Duration` and 3 other fields	High correlation
`Product_Pages` is highly correlated with `AccountMng_Pages` and 3 other fields	High correlation
`Product_Duration` is highly correlated with `AccountMng_Duration` and 3 other fields	High correlation
`GoogleAnalytics_BounceRate` is highly correlated with `GoogleAnalytics_ExitRate`	High correlation
`GoogleAnalytics_ExitRate` is highly correlated with `GoogleAnalytics_BounceRate`	High correlation
`OS` is highly correlated with `Browser` and 1 other fields	High correlation
`Browser` is highly correlated with `OS` and 1 other fields	High correlation
`Type_of_Visitor` is highly correlated with `OS` and 1 other fields	High correlation
`Access_ID` has unique values	Unique
`AccountMng_Pages` has 4672 (46.7%) zeros	Zeros
`AccountMng_Duration` has 4785 (47.9%) zeros	Zeros
`FAQ_Pages` has 7854 (78.5%) zeros	Zeros
`FAQ_Duration` has 8030 (80.3%) zeros	Zeros
`Product_Duration` has 628 (6.3%) zeros	Zeros
`GoogleAnalytics_BounceRate` has 4471 (44.7%) zeros	Zeros
`GoogleAnalytics_PageValue` has 7766 (77.7%) zeros	Zeros

Reproduction

Analysis started	2021-11-02 19:33:44.223722
Analysis finished	2021-11-02 19:33:57.957910
Duration	13.73 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Access_ID
Real number (ℝ_≥0)

UNIQUE

Distinct	9999
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	451972765.8

Minimum	102863333
Maximum	798444008
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	102863333
5-th percentile	136989382.8
Q1	273194966
median	453616869
Q3	625975569.5
95-th percentile	767250890.1
Maximum	798444008
Range	695580675
Interquartile range (IQR)	352780603.5

Descriptive statistics

Standard deviation	202498979.6
Coefficient of variation (CV)	0.4480335874
Kurtosis	-1.211334006
Mean	451972765.8
Median Absolute Deviation (MAD)	176832666
Skewness	-0.003298733964
Sum	4.519275685 × 10¹²
Variance	4.100583676 × 10¹⁶
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102863333	1	< 0.1%
570524579	1	< 0.1%
570216020	1	< 0.1%
570274432	1	< 0.1%
570361797	1	< 0.1%
570405487	1	< 0.1%
570425083	1	< 0.1%
570476495	1	< 0.1%
570504051	1	< 0.1%
570651528	1	< 0.1%
Other values (9989)	9989	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
102863333	1	< 0.1%
103117814	1	< 0.1%
103201891	1	< 0.1%
103226087	1	< 0.1%
103234445	1	< 0.1%
103237767	1	< 0.1%
103271040	1	< 0.1%
103279585	1	< 0.1%
103348992	1	< 0.1%
103364259	1	< 0.1%

Value	Count	Frequency (%)
798444008	1	< 0.1%
798371242	1	< 0.1%
798339820	1	< 0.1%
798314158	1	< 0.1%
798279589	1	< 0.1%
798164578	1	< 0.1%
798136425	1	< 0.1%
798104528	1	< 0.1%
798013226	1	< 0.1%
797955809	1	< 0.1%

Date
Categorical

HIGH CARDINALITY

Distinct	305
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	641.7 KiB

25-May-20	120
5-May-20	111
7-May-20	110
14-May-20	110
8-May-20	109
Other values (300)	9439

Length

Max length	9
Median length	9
Mean length	8.706970697
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	21-Mar-20
2nd row	20-May-20
3rd row	4-Dec-20
4th row	22-Dec-20
5th row	24-Nov-20

Common Values

Value	Count	Frequency (%)
25-May-20	120	1.2%
5-May-20	111	1.1%
7-May-20	110	1.1%
14-May-20	110	1.1%
8-May-20	109	1.1%
6-Nov-20	107	1.1%
22-May-20	106	1.1%
19-May-20	106	1.1%
11-May-20	106	1.1%
26-May-20	105	1.1%
Other values (295)	8909	89.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
25-may-20	120	1.2%
5-may-20	111	1.1%
7-may-20	110	1.1%
14-may-20	110	1.1%
8-may-20	109	1.1%
6-nov-20	107	1.1%
22-may-20	106	1.1%
19-may-20	106	1.1%
11-may-20	106	1.1%
20-may-20	105	1.1%
Other values (295)	8909	89.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

AccountMng_Pages
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	27
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.324232423

Minimum	0
Maximum	27
Zeros	4672
Zeros (%)	46.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	9
Maximum	27
Range	27
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.34067596
Coefficient of variation (CV)	1.437324394
Kurtosis	4.850987396
Mean	2.324232423
Median Absolute Deviation (MAD)	1
Skewness	1.97987619
Sum	23240
Variance	11.16011587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	4672	46.7%
1	1103	11.0%
2	900	9.0%
3	735	7.4%
4	628	6.3%
5	458	4.6%
6	357	3.6%
7	277	2.8%
8	230	2.3%
9	180	1.8%
Other values (17)	459	4.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4672	46.7%
1	1103	11.0%
2	900	9.0%
3	735	7.4%
4	628	6.3%
5	458	4.6%
6	357	3.6%
7	277	2.8%
8	230	2.3%
9	180	1.8%

Value	Count	Frequency (%)
27	1	< 0.1%
26	1	< 0.1%
24	4	< 0.1%
23	2	< 0.1%
22	3	< 0.1%
21	2	< 0.1%
20	2	< 0.1%
19	5	0.1%
18	12	0.1%
17	14	0.1%

AccountMng_Duration
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2838
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	81.20585434

Minimum	0
Maximum	3398.75
Zeros	4785
Zeros (%)	47.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	7.5
Q3	92.20835
95-th percentile	352.37003
Maximum	3398.75
Range	3398.75
Interquartile range (IQR)	92.20835

Descriptive statistics

Standard deviation	179.715545
Coefficient of variation (CV)	2.213086069
Kurtosis	49.5010676
Mean	81.20585434
Median Absolute Deviation (MAD)	7.5
Skewness	5.605178491
Sum	811977.3375
Variance	32297.6771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4785	47.9%
4	49	0.5%
11	38	0.4%
7	37	0.4%
5	37	0.4%
6	34	0.3%
14	31	0.3%
9	28	0.3%
15	27	0.3%
10	25	0.3%
Other values (2828)	4908	49.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4785	47.9%
1.3333	1	< 0.1%
2	13	0.1%
3	22	0.2%
3.5	2	< 0.1%
4	49	0.5%
4.5	1	< 0.1%
4.75	1	< 0.1%
5	37	0.4%
5.0667	1	< 0.1%

Value	Count	Frequency (%)
3398.75	1	< 0.1%
2657.3181	1	< 0.1%
2629.254	1	< 0.1%
2407.4238	1	< 0.1%
2137.1127	1	< 0.1%
2086.75	1	< 0.1%
2047.2348	1	< 0.1%
1951.2791	1	< 0.1%
1946	1	< 0.1%
1922	1	< 0.1%

FAQ_Pages
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5080508051

Minimum	0
Maximum	24
Zeros	7854
Zeros (%)	78.5%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	24
Range	24
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.279389526
Coefficient of variation (CV)	2.51823147
Kurtosis	28.77693983
Mean	0.5080508051
Median Absolute Deviation (MAD)	0
Skewness	4.107353861
Sum	5080
Variance	1.636837559
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	7854	78.5%
1	844	8.4%
2	592	5.9%
3	313	3.1%
4	180	1.8%
5	84	0.8%
6	67	0.7%
7	30	0.3%
9	13	0.1%
8	8	0.1%
Other values (7)	14	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7854	78.5%
1	844	8.4%
2	592	5.9%
3	313	3.1%
4	180	1.8%
5	84	0.8%
6	67	0.7%
7	30	0.3%
8	8	0.1%
9	13	0.1%

Value	Count	Frequency (%)
24	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	1	< 0.1%
12	4	< 0.1%
11	1	< 0.1%
10	4	< 0.1%
9	13	0.1%
8	8	0.1%
7	30	0.3%

FAQ_Duration
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1089
Distinct (%)	10.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.55910121

Minimum	0
Maximum	2549.375
Zeros	8030
Zeros (%)	80.3%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	200.1
Maximum	2549.375
Range	2549.375
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	139.796989
Coefficient of variation (CV)	4.045156966
Kurtosis	78.14365909
Mean	34.55910121
Median Absolute Deviation (MAD)	0
Skewness	7.627079075
Sum	345556.453
Variance	19543.19814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8030	80.3%
9	25	0.3%
10	21	0.2%
12	20	0.2%
6	20	0.2%
7	20	0.2%
11	20	0.2%
13	19	0.2%
16	18	0.2%
8	18	0.2%
Other values (1079)	1788	17.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8030	80.3%
1	3	< 0.1%
1.5	1	< 0.1%
2	8	0.1%
2.5	1	< 0.1%
3	14	0.1%
4	15	0.2%
5	12	0.1%
5.5	2	< 0.1%
6	20	0.2%

Value	Count	Frequency (%)
2549.375	1	< 0.1%
2256.9167	1	< 0.1%
2195.3	1	< 0.1%
2166.5	1	< 0.1%
2050.4333	1	< 0.1%
1949.1667	1	< 0.1%
1830.5	1	< 0.1%
1779.1667	1	< 0.1%
1778	1	< 0.1%
1767.6667	1	< 0.1%

Product_Pages
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	291
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.68586859

Minimum	0
Maximum	705
Zeros	33
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	7
median	18
Q3	38
95-th percentile	109
Maximum	705
Range	705
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	44.55027695
Coefficient of variation (CV)	1.405998287
Kurtosis	33.12990553
Mean	31.68586859
Median Absolute Deviation (MAD)	13
Skewness	4.448047888
Sum	316827
Variance	1984.727177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	522	5.2%
2	373	3.7%
3	367	3.7%
4	336	3.4%
6	319	3.2%
7	315	3.2%
5	310	3.1%
8	293	2.9%
10	269	2.7%
12	255	2.6%
Other values (281)	6640	66.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.3%
1	522	5.2%
2	373	3.7%
3	367	3.7%
4	336	3.4%
5	310	3.1%
6	319	3.2%
7	315	3.2%
8	293	2.9%
9	247	2.5%

Value	Count	Frequency (%)
705	1	< 0.1%
686	1	< 0.1%
584	1	< 0.1%
518	1	< 0.1%
517	1	< 0.1%
501	1	< 0.1%
486	1	< 0.1%
470	1	< 0.1%
449	1	< 0.1%
440	1	< 0.1%

Product_Duration
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7884
Distinct (%)	78.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1199.76943

Minimum	0
Maximum	63973.5222
Zeros	628
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	183.5625
median	599
Q3	1470.2708
95-th percentile	4284.7764
Maximum	63973.5222
Range	63973.5222
Interquartile range (IQR)	1286.7083

Descriptive statistics

Standard deviation	1958.276304
Coefficient of variation (CV)	1.632210536
Kurtosis	151.7253116
Mean	1199.76943
Median Absolute Deviation (MAD)	501.5
Skewness	7.810046833
Sum	11996494.53
Variance	3834846.083
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	628	6.3%
17	19	0.2%
8	15	0.2%
11	15	0.2%
15	14	0.1%
19	13	0.1%
12	13	0.1%
22	12	0.1%
59	12	0.1%
5	12	0.1%
Other values (7874)	9246	92.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	628	6.3%
0.5	1	< 0.1%
1	1	< 0.1%
2.3333	1	< 0.1%
2.6667	1	< 0.1%
3	3	< 0.1%
4	5	0.1%
5	12	0.1%
5.3333	1	< 0.1%
6	4	< 0.1%

Value	Count	Frequency (%)
63973.5222	1	< 0.1%
43171.2334	1	< 0.1%
29970.466	1	< 0.1%
27009.8594	1	< 0.1%
24844.1562	1	< 0.1%
23888.81	1	< 0.1%
23342.0821	1	< 0.1%
23050.1041	1	< 0.1%
21857.0465	1	< 0.1%
21672.2443	1	< 0.1%

GoogleAnalytics_BounceRate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	516
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02230545055

Minimum	0
Maximum	0.2
Zeros	4471
Zeros (%)	44.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.0032
Q3	0.0168
95-th percentile	0.2
Maximum	0.2
Range	0.2
Interquartile range (IQR)	0.0168

Descriptive statistics

Standard deviation	0.04877597427
Coefficient of variation (CV)	2.186728942
Kurtosis	7.648446986
Mean	0.02230545055
Median Absolute Deviation (MAD)	0.0032
Skewness	2.940060119
Sum	223.0322
Variance	0.002379095666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4471	44.7%
0.2	581	5.8%
0.0667	113	1.1%
0.0286	95	1.0%
0.05	87	0.9%
0.0333	82	0.8%
0.04	81	0.8%
0.025	80	0.8%
0.1	80	0.8%
0.0125	79	0.8%
Other values (506)	4250	42.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4471	44.7%
0.0001	7	0.1%
0.0002	8	0.1%
0.0003	10	0.1%
0.0004	8	0.1%
0.0005	6	0.1%
0.0006	11	0.1%
0.0007	10	0.1%
0.0008	15	0.2%
0.0009	12	0.1%

Value	Count	Frequency (%)
0.2	581	5.8%
0.1833	1	< 0.1%
0.18	4	< 0.1%
0.175	1	< 0.1%
0.1667	3	< 0.1%
0.1643	1	< 0.1%
0.16	3	< 0.1%
0.1556	3	< 0.1%
0.15	11	0.1%
0.1467	1	< 0.1%

GoogleAnalytics_ExitRate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	857
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04318146815

Minimum	0
Maximum	0.2
Zeros	61
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0048
Q1	0.0143
median	0.0251
Q3	0.05
95-th percentile	0.2
Maximum	0.2
Range	0.2
Interquartile range (IQR)	0.0357

Descriptive statistics

Standard deviation	0.04884527615
Coefficient of variation (CV)	1.131162933
Kurtosis	3.985723873
Mean	0.04318146815
Median Absolute Deviation (MAD)	0.0142
Skewness	2.146976695
Sum	431.7715
Variance	0.002385861002
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	591	5.9%
0.1	274	2.7%
0.05	274	2.7%
0.0333	230	2.3%
0.0667	222	2.2%
0.025	179	1.8%
0.04	177	1.8%
0.0167	156	1.6%
0.02	136	1.4%
0.0222	135	1.4%
Other values (847)	7625	76.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	61	0.6%
0.0003	4	< 0.1%
0.0004	1	< 0.1%
0.0005	4	< 0.1%
0.0006	2	< 0.1%
0.0007	4	< 0.1%
0.0008	3	< 0.1%
0.0009	1	< 0.1%
0.001	5	0.1%
0.0011	4	< 0.1%

Value	Count	Frequency (%)
0.2	591	5.9%
0.1889	2	< 0.1%
0.1867	3	< 0.1%
0.1833	1	< 0.1%
0.1818	1	< 0.1%
0.18	2	< 0.1%
0.1778	4	< 0.1%
0.175	4	< 0.1%
0.1738	1	< 0.1%
0.1733	1	< 0.1%

GoogleAnalytics_PageValue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2203
Distinct (%)	22.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.963120292

Minimum	0
Maximum	361.7637
Zeros	7766
Zeros (%)	77.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	38.61663
Maximum	361.7637
Range	361.7637
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	18.75362571
Coefficient of variation (CV)	3.144935
Kurtosis	67.18704665
Mean	5.963120292
Median Absolute Deviation (MAD)	0
Skewness	6.430619989
Sum	59625.2398
Variance	351.6984774
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7766	77.7%
53.988	5	0.1%
42.2931	3	< 0.1%
15.3956	2	< 0.1%
54.98	2	< 0.1%
4.5111	2	< 0.1%
44.8935	2	< 0.1%
5.6986	2	< 0.1%
9.6411	2	< 0.1%
26.5455	2	< 0.1%
Other values (2193)	2211	22.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7766	77.7%
0.038	1	< 0.1%
0.067	1	< 0.1%
0.0935	1	< 0.1%
0.1207	1	< 0.1%
0.1297	1	< 0.1%
0.1318	1	< 0.1%
0.1392	1	< 0.1%
0.1507	1	< 0.1%
0.1522	1	< 0.1%

Value	Count	Frequency (%)
361.7637	1	< 0.1%
360.9534	1	< 0.1%
287.9538	1	< 0.1%
270.7847	1	< 0.1%
261.4913	1	< 0.1%
254.6072	1	< 0.1%
246.7586	1	< 0.1%
239.98	1	< 0.1%
226.6777	1	< 0.1%
218.3952	1	< 0.1%

OS
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	621.5 KiB

Windows	5361
Android	2104
MacOSX	2065
iOS	378
Ubuntu	68
Other values (3)	23

Length

Max length	9
Median length	7
Mean length	6.637163716
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MacOSX
2nd row	Windows
3rd row	Windows
4th row	Windows
5th row	Windows

Common Values

Value	Count	Frequency (%)
Windows	5361	53.6%
Android	2104	21.0%
MacOSX	2065	20.7%
iOS	378	3.8%
Ubuntu	68	0.7%
Chrome OS	15	0.2%
Other	5	0.1%
Fedora	3	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
windows	5361	53.5%
android	2104	21.0%
macosx	2065	20.6%
ios	378	3.8%
ubuntu	68	0.7%
chrome	15	0.1%
os	15	0.1%
other	5	< 0.1%
fedora	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Browser
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.352535254

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	5
Maximum	13
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.715698122
Coefficient of variation (CV)	0.7292975184
Kurtosis	13.01326822
Mean	2.352535254
Median Absolute Deviation (MAD)	0
Skewness	3.276346893
Sum	23523
Variance	2.943620047
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	6484	64.8%
1	1990	19.9%
4	597	6.0%
5	362	3.6%
6	138	1.4%
10	130	1.3%
8	113	1.1%
3	81	0.8%
13	52	0.5%
7	41	0.4%
Other values (2)	11	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1990	19.9%
2	6484	64.8%
3	81	0.8%
4	597	6.0%
5	362	3.6%
6	138	1.4%
7	41	0.4%
8	113	1.1%
10	130	1.3%
11	3	< 0.1%

Value	Count	Frequency (%)
13	52	0.5%
12	8	0.1%
11	3	< 0.1%
10	130	1.3%
8	113	1.1%
7	41	0.4%
6	138	1.4%
5	362	3.6%
4	597	6.0%
3	81	0.8%

Country
Categorical

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	624.7 KiB

Portugal	3870
Spain	1945
Brazil	947
France	923
Other	659
Other values (4)	1655

Length

Max length	14
Median length	6
Mean length	6.96209621
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Portugal
2nd row	France
3rd row	Italy
4th row	United Kingdom
5th row	Spain

Common Values

Value	Count	Frequency (%)
Portugal	3870	38.7%
Spain	1945	19.5%
Brazil	947	9.5%
France	923	9.2%
Other	659	6.6%
Italy	613	6.1%
United Kingdom	429	4.3%
Germany	350	3.5%
Switzerland	263	2.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
portugal	3870	37.1%
spain	1945	18.7%
brazil	947	9.1%
france	923	8.9%
other	659	6.3%
italy	613	5.9%
united	429	4.1%
kingdom	429	4.1%
germany	350	3.4%
switzerland	263	2.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Type_of_Traffic
Real number (ℝ_≥0)

Distinct	15
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.95749575

Minimum	1
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	4
95-th percentile	13
Maximum	15
Range	14
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	3.67515917
Coefficient of variation (CV)	0.9286577682
Kurtosis	1.410794103
Mean	3.95749575
Median Absolute Deviation (MAD)	1
Skewness	1.612960454
Sum	39571
Variance	13.50679493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
2	3150	31.5%
1	2008	20.1%
3	1676	16.8%
4	870	8.7%
13	595	6.0%
10	355	3.6%
6	354	3.5%
8	284	2.8%
5	210	2.1%
11	205	2.1%
Other values (5)	292	2.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2008	20.1%
2	3150	31.5%
3	1676	16.8%
4	870	8.7%
5	210	2.1%
6	354	3.5%
7	31	0.3%
8	284	2.8%
9	34	0.3%
10	355	3.6%

Value	Count	Frequency (%)
15	156	1.6%
14	27	0.3%
13	595	6.0%
12	44	0.4%
11	205	2.1%
10	355	3.6%
9	34	0.3%
8	284	2.8%
7	31	0.3%
6	354	3.5%

Type_of_Visitor
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	637.3 KiB

Returner	8534
New_Access	1391
Other	74

Length

Max length	10
Median length	8
Mean length	8.256025603
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Returner
2nd row	Returner
3rd row	Returner
4th row	Returner
5th row	Returner

Common Values

Value	Count	Frequency (%)
Returner	8534	85.3%
New_Access	1391	13.9%
Other	74	0.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
returner	8534	85.3%
new_access	1391	13.9%
other	74	0.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Buy
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	566.5 KiB

0	8447
1	1552

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	8447	84.5%
1	1552	15.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	8447	84.5%
1	1552	15.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Access_ID	Date	AccountMng_Pages	AccountMng_Duration	FAQ_Pages	FAQ_Duration	Product_Pages	Product_Duration	GoogleAnalytics_BounceRate	GoogleAnalytics_ExitRate	GoogleAnalytics_PageValue	OS	Browser	Country	Type_of_Traffic	Type_of_Visitor	Buy
0	102863333	21-Mar-20	0	0.0000	0	0.0	3	64.0000	0.0000	0.0667	0.0000	MacOSX	2	Portugal	1	Returner	0
1	103117814	20-May-20	0	0.0000	0	0.0	23	684.5000	0.0217	0.0449	0.0000	Windows	2	France	6	Returner	0
2	103201891	4-Dec-20	0	0.0000	0	0.0	8	95.0000	0.0250	0.0583	0.0000	Windows	4	Italy	1	Returner	0
3	103226087	22-Dec-20	0	0.0000	0	0.0	9	608.7500	0.0000	0.0250	42.4225	Windows	2	United Kingdom	2	Returner	1
4	103234445	24-Nov-20	0	0.0000	2	386.0	36	1609.9397	0.0000	0.0093	12.5033	Windows	2	Spain	3	Returner	1
5	103237767	4-Mar-20	3	13.0000	0	0.0	28	324.7692	0.0000	0.0017	0.0000	Windows	2	Portugal	6	Returner	0
6	103271040	3-Nov-20	15	270.0167	3	122.0	66	2780.6000	0.0000	0.0165	0.0000	Windows	2	Spain	10	Returner	0
7	103279585	19-Mar-20	0	0.0000	0	0.0	12	249.5000	0.0056	0.0250	0.0000	Windows	7	Italy	1	Returner	0
8	103348992	26-Mar-20	0	0.0000	0	0.0	3	30.0000	0.0000	0.0667	0.0000	Windows	2	Portugal	1	Returner	0
9	103364259	13-Mar-20	0	0.0000	0	0.0	17	469.4167	0.0000	0.0118	0.0000	Android	1	France	2	Returner	0

Last rows

	Access_ID	Date	AccountMng_Pages	AccountMng_Duration	FAQ_Pages	FAQ_Duration	Product_Pages	Product_Duration	GoogleAnalytics_BounceRate	GoogleAnalytics_ExitRate	GoogleAnalytics_PageValue	OS	Browser	Country	Type_of_Traffic	Type_of_Visitor	Buy
9989	797955809	22-Nov-20	7	91.2500	1	0.0	95	2900.7917	0.0040	0.0233	4.4857	Windows	2	Portugal	2	Returner	1
9990	798013226	18-May-20	8	57.8333	1	3.0	115	8388.3161	0.0125	0.0295	0.0000	MacOSX	2	France	6	Returner	0
9991	798104528	4-Dec-20	6	461.0000	0	0.0	4	111.0000	0.0000	0.0111	0.0000	MacOSX	3	Spain	8	New_Access	0
9992	798136425	18-May-20	0	0.0000	0	0.0	20	289.7500	0.0000	0.0250	0.0000	Android	1	Brazil	3	Returner	0
9993	798164578	8-May-20	0	0.0000	0	0.0	16	462.7333	0.0125	0.0469	0.0000	Android	1	Portugal	3	Returner	0
9994	798279589	8-May-20	3	159.0000	2	55.5	23	1100.1250	0.0000	0.0111	0.0000	MacOSX	2	Brazil	14	Returner	0
9995	798314158	17-Jul-20	6	175.1000	0	0.0	3	27.6000	0.0000	0.0111	0.0000	Windows	10	Spain	5	New_Access	0
9996	798339820	23-Mar-20	0	0.0000	0	0.0	27	644.0000	0.0077	0.0519	0.0000	MacOSX	2	France	3	Returner	0
9997	798371242	16-May-20	0	0.0000	0	0.0	53	715.5000	0.0226	0.0363	0.0000	Windows	2	Italy	3	Returner	0
9998	798444008	20-Nov-20	0	0.0000	0	0.0	23	1919.5500	0.0087	0.0319	4.2803	Windows	2	Brazil	1	Returner	0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows